www.gusucode.com > XerCMS 携云PHP企业建站程序 v2015PHP源码程序 > XerCMS 携云PHP企业建站程序 v2015/XerCMS_v20150724/XerCMS_v20150724/XerCMS/Utils/tables/XerCMS_forum.php
<?php /** * @name XERCMS * @author Arno <XerCMS@163.com> [QQ:1328013] * @version 1.0.0 * @link http://www.XerCMS.com */ !defined('XERCMS') && exit('Access Denied'); class TABLE_forum extends resource { private $data = NULL; private $defaultTable = 'xercms_forum'; function __construct() { $this->table = $this->defaultTable; } function delboard($bid) { return DB::query('DELETE FROM xercms_forum_board WHERE bid = '.(int)$bid); } function board_count($parent = null) { return DB::result_first('SELECT count(*) FROM xercms_forum_board'.($parent === null ? '' : ' WHERE parent = '.(int)$parent)); } function posts($page,$number = 30,$uid = 0) { $uid = empty($uid) ? X::$G['uid'] : $uid; return DB::fetch_all('SELECT t.*,p.*,m.nick FROM xercms_forum_topic t,xercms_forum_posts p,xercms_member_profile m WHERE t.tid = p.tid and t.uid = m.uid and m.uid = p.uid and p.uid = '.X::$G['uid'].' group by p.uid limit '.(($page-1)*$number).','.$number); } function topic($page,$number = 30,$uid = 0) { $uid = empty($uid) ? X::$G['uid'] : $uid; return DB::fetch_all('SELECT t.*,m.nick FROM xercms_forum_topic t,xercms_member_profile m WHERE m.uid = t.uid and t.uid = '.X::$G['uid'].' limit '.(($page-1)*$number).','.$number); } function count($field ,$uid = 0) { $uid = empty($uid) ? X::$G['uid'] : $uid; return DB::result_first('SELECT '.$field.' FROM xercms_member_count WHERE uid = '.X::$G['uid']); } } ?>